package com.bw.mapper;

import com.bw.bean.User;
import com.bw.bean.Vo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface VoMapper {
    @Select("select bp.name,sum(oi.final_total_amount) `value`\n" +
            "from  order_info oi\n" +
            "left join base_province bp on oi.province_id = bp.id\n" +
            "group by bp.name;")
    List<Vo> getList1();


    @Select("select sum(final_total_amount)  from order_info")
    Double getList2();

    @Select("select *  from  user_info")
    List<User> getList3();
}
